Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
AccountNumber (PK) | The CUSTOMER's account number against which previous tender authorization is held. | ID_ACNT_NMB | Identity | integer | |
TenderAuthorizationProviderID (FK) | A unique system defined identifier for the Provider. | ID_PRV | Identity | integer | TenderAuthorizationProvider(PA_TND_AZN_PVR) |
TenderAuthorizationPermissionFlag | Flag that grants or revokes permission to accept this tender for this account. | FL_PRMS | Flag | integer | |
TenderAuthorizationFollowUpActionCode | A retailer defined code that indicates that follow up action may be required by the retailer after accepting or rejecting a customer tender. | LU_ACTN_FLW_UP | Code2 | char(2) | |
CeilingLimitAmount | The monetary amount up to which approval can be sought. | UL_APVL_TND | Money | decimal(16,5) | |
TenderAuthorizationLastActionCode | A retailer defined code that indicates the last action taken on this approval reference. Examples include an increase or decrease in the ceiling limit amount. | LU_ACTN_LS | Code2 | char(2) | |
TenderIssuingBankID | The bank or financial services organization that issued the credit or debit card. | ID_BK_TND_ISSG | Identity | integer | |
CreateDateTimestamp | The date and time this tender approval reference was created. | TS_CRT_TND_APVL | AuditDateTime | datetime | |
LastUpdateDateTimestamp | The date and time the tender approval reference was last modified. | TS_UPDT_LS_APVL | AuditDateTime | datetime | |
LastApprovalGivenDateTimestamp | The date and time this tender approval reference last approved a tender payment at the store. | TS_APVL_TND_LS_GVN | AuditDateTime | datetime | |